Creating Execute Package Task 13

·         Always make Sure Dimension tables should loaded first and then load the Fact tables
·         We need five Execute Package Task for populating Four Dimension and one Fact tables
·         Right Click on SSIS Packages ---- > New SSIS Package        

        ·         Right Click on Package1.dtsx ----- > Click Rename ----- > Type Loading Dim and Fact Tables

        

        ·         Drag and Drop Execute Package Task from SSIS Toolbox

        

        ·         Right Click on Execute Package Task at Control flow Task ----- > Click Rename ---- > Type Populating Dim_Contract ----- > Click Enter

        

        ·         After renaming it appears like below

        

        ·         Double Click on Populating Dim_Contract

        

        ·         Click Packages ---- > Click on the Drop Down of the Package name from Project reference ---- > Choose Dim_Contract.dtsx ----- > Click Ok

        

        ·         Drag and Drop Execute Package Task below the Populating Dim_Contract

        

 ·         Provide the Connection by Dragging Green arrow and Place it on Top of Execute Package Task        


        ·         Right Click on Execute Package Task ---- > Click Rename ---- >  Type Populating Dim_Mortgage        

        ·         Double Click on Populating Dim_Mortgage

         

        ·         Click on Package ---- > Click on Drop Down of Package Name from Project Reference ----- > Choose Dim_Mortgage.dtsx

         

        ·         Drag and Drop Execute Package Task below Populating Dim_Mortgage

        ·         Provide the Connection by Dragging Green arrow and place it on top of Execute Package Task

        

        ·         Right Click on Execute Package Task ---- > Click Rename ---- >  Type Populating Dim_Owner

        

        ·         Double Click on Populating Dim_Owner

        

        ·         Click on Package ---- > Click on Drop Down of Package Name from Project Reference ----- > Choose Dim_Owner.dtsx

        

        ·         Drag and Drop Execute Package Task below Populating Dim_Owner

        ·         Provide the Connection by Dragging Green arrow and place it on top of Execute Package Task

        

        ·         Right Click on Execute Package Task ---- > Click Rename ---- >  Type Populating Dim_Property

        

        ·         Double Click on Populating Dim_Property

        

        ·         Click on Package ---- > Click on Drop Down of Package Name from Project Reference ----- > Choose Dim_Property.dtsx

        

        ·         Drag and Drop Execute Package Task below Populating Dim_Property

        ·         Provide the Connection by Dragging Green arrow and place it on top of Execute Package Task

        

        ·         Right Click on Execute Package Task ---- > Click Rename ---- >  Type Populating Fact_Mortgage

        ·         Double Click on Populating Fact_Mortgage

        

        ·         Click on Package ---- > Click on Drop Down of Package Name from Project Reference ----- > Choose Fact_Mortgage.dtsx

        

        ·         Finally Package looks like below

        

        ·         To execute the Package ---- > Click Start at Top

        

        ·         Files are executed successfully without any error

        

        ·         All the Tables are populated with values.

        ·         In SQL Server Management Studio, Use the Code to see Whether the Tables are Populated

        Script for Dim_Contract

        USE           [Mortgage Datamart]

        GO

        Select        *  From Dim_Contract

        ·         Copy and Paste the Code in Query Window ---- > Click Execute

        ·         Dim_Contract table is populated with records

        

        Script to check Dim_Mortgage

        USE[Mortgage Datamart]

      GO

        Select    *  From Dim_Mortgage

        ·         Copy and Paste the Code in Query Window ---- > Click Execute

        ·         Dim_Mortgage table is populated with records

        

        Script to check Dim_Owner

        USE[Mortgage Datamart]    

        GO

      Select   *  From Dim_Owner

        ·         Copy and Paste the Code in Query Window ---- > Click Execute

        ·         Dim_Owner table is populated with records

        

        Script to Check Dim_Property 

        USE[Mortgage Datamart]

        GO

        Select   *  From Dim_Property 

        ·         Copy and Paste the Code in Query Window ---- > Click Execute

        ·         Dim_Property table is populated with records

        

        Script to Check Fact_Mortgage Table

        USE           [Mortgage Datamart]

        Go

        Select        * From  Fact_Mortgage

        ·         Copy and Paste the Code in Query Window ---- > Click Execute         

·     ·           Fact_Mortgage table is populated with records

        

        

Video for Execute package Task

https://www.youtube.com/watch?v=kSnHxMgG110